{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Copy of ANM trace anomaly extraction",
      "provenance": [],
      "collapsed_sections": [],
      "machine_shape": "hm"
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "A27e_mLs3TnV",
        "outputId": "3a85b208-bc0d-458c-971b-498fe6094688"
      },
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "F5Udi9bnhwoV"
      },
      "source": [
        "import pandas as pd"
      ],
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZU5dns4r860K"
      },
      "source": [
        "TRACE_PATH = '/content/drive/MyDrive/anmproject/training_data (1).zip (Unzipped Files)/training_data/2020_05_04/trace/'"
      ],
      "execution_count": 3,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "H8of7SKh_ZHT"
      },
      "source": [
        "import os\r\n",
        "filenames = os.listdir(TRACE_PATH)\r\n",
        "datasets = [pd.read_csv(TRACE_PATH+file) for file in filenames]\r\n",
        "\r\n",
        "for i, df in enumerate(datasets):\r\n",
        "    if df['callType'].iloc[0] == 'JDBC':\r\n",
        "      df['serviceName'] = df['dsName']\r\n",
        "      df = df.drop(['dsName'], axis=1)\r\n",
        "    elif df['callType'].iloc[0] == 'LOCAL':\r\n",
        "      df = df.drop(['dsName'], axis=1)\r\n",
        "    datasets[i] = df"
      ],
      "execution_count": 4,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "kD31wi5LCChC",
        "outputId": "3cbe6ded-af43-443b-d4bb-f9842a6debbd"
      },
      "source": [
        "datasets"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[        callType      startTime  ...     cmdb_id  serviceName\n",
              " 0            CSF  1588521600025  ...      os_021      csf_001\n",
              " 1            CSF  1588521600026  ...      os_021      csf_001\n",
              " 2            CSF  1588521600027  ...      os_021      csf_001\n",
              " 3            CSF  1588521600028  ...      os_022      csf_001\n",
              " 4            CSF  1588521600028  ...      os_021      csf_001\n",
              " ...          ...            ...  ...         ...          ...\n",
              " 3650200      CSF  1588607984997  ...  docker_002      csf_005\n",
              " 3650201      CSF  1588607985000  ...  docker_002      csf_004\n",
              " 3650202      CSF  1588607985039  ...  docker_003      csf_004\n",
              " 3650203      CSF  1588607985064  ...  docker_003      csf_005\n",
              " 3650204      CSF  1588607985203  ...  docker_002      csf_005\n",
              " \n",
              " [3650205 rows x 9 columns],\n",
              "        callType      startTime  elapsedTime  ...   pid cmdb_id serviceName\n",
              " 0           OSB  1588521600016        747.0  ...  None  os_021     osb_001\n",
              " 1           OSB  1588521600019       1132.0  ...  None  os_021     osb_001\n",
              " 2           OSB  1588521600019       1487.0  ...  None  os_021     osb_001\n",
              " 3           OSB  1588521600021       1126.0  ...  None  os_022     osb_001\n",
              " 4           OSB  1588521600022        738.0  ...  None  os_021     osb_001\n",
              " ...         ...            ...          ...  ...   ...     ...         ...\n",
              " 730036      OSB  1588607984481       1024.0  ...  None  os_022     osb_001\n",
              " 730037      OSB  1588607984664        304.0  ...  None  os_021     osb_001\n",
              " 730038      OSB  1588607984671        300.0  ...  None  os_021     osb_001\n",
              " 730039      OSB  1588607984790        192.0  ...  None  os_022     osb_001\n",
              " 730040      OSB  1588607984800        327.0  ...  None  os_021     osb_001\n",
              " \n",
              " [730041 rows x 9 columns],\n",
              "               callType      startTime  ...     cmdb_id  serviceName\n",
              " 0        RemoteProcess  1588521600027  ...  docker_003      csf_001\n",
              " 1        RemoteProcess  1588521600028  ...  docker_003      csf_001\n",
              " 2        RemoteProcess  1588521600029  ...  docker_003      csf_001\n",
              " 3        RemoteProcess  1588521600030  ...  docker_003      csf_001\n",
              " 4        RemoteProcess  1588521600031  ...  docker_001      csf_001\n",
              " ...                ...            ...  ...         ...          ...\n",
              " 3650200  RemoteProcess  1588607985000  ...  docker_008      csf_005\n",
              " 3650201  RemoteProcess  1588607985042  ...  docker_006      csf_004\n",
              " 3650202  RemoteProcess  1588607985067  ...  docker_006      csf_005\n",
              " 3650203  RemoteProcess  1588607985093  ...  docker_007      csf_004\n",
              " 3650204  RemoteProcess  1588607985208  ...  docker_007      csf_005\n",
              " \n",
              " [3650205 rows x 9 columns],\n",
              "          callType      startTime  ...     cmdb_id     serviceName\n",
              " 0       FlyRemote  1588521600033  ...  docker_003  fly_remote_001\n",
              " 1       FlyRemote  1588521600035  ...  docker_004  fly_remote_001\n",
              " 2       FlyRemote  1588521600035  ...  docker_003  fly_remote_001\n",
              " 3       FlyRemote  1588521600036  ...  docker_003  fly_remote_001\n",
              " 4       FlyRemote  1588521600036  ...  docker_001  fly_remote_001\n",
              " ...           ...            ...  ...         ...             ...\n",
              " 730036  FlyRemote  1588607984675  ...  docker_003  fly_remote_001\n",
              " 730037  FlyRemote  1588607984683  ...  docker_003  fly_remote_001\n",
              " 730038  FlyRemote  1588607984693  ...  docker_002  fly_remote_001\n",
              " 730039  FlyRemote  1588607984804  ...  docker_001  fly_remote_001\n",
              " 730040  FlyRemote  1588607984849  ...  docker_003  fly_remote_001\n",
              " \n",
              " [730041 rows x 9 columns],\n",
              "          callType      startTime  ...     cmdb_id       serviceName\n",
              " 0           LOCAL  1588521600062  ...  docker_006  local_method_011\n",
              " 1           LOCAL  1588521600071  ...  docker_008  local_method_011\n",
              " 2           LOCAL  1588521600072  ...  docker_006  local_method_011\n",
              " 3           LOCAL  1588521600073  ...  docker_006  local_method_011\n",
              " 4           LOCAL  1588521600073  ...  docker_006  local_method_011\n",
              " ...           ...            ...  ...         ...               ...\n",
              " 14600815    LOCAL  1588607985396  ...  docker_002  local_method_006\n",
              " 14600816    LOCAL  1588607985397  ...  docker_002  local_method_007\n",
              " 14600817    LOCAL  1588607985399  ...  docker_002  local_method_006\n",
              " 14600818    LOCAL  1588607985400  ...  docker_002  local_method_009\n",
              " 14600819    LOCAL  1588607985403  ...  docker_002  local_method_010\n",
              " \n",
              " [14600820 rows x 9 columns],\n",
              "          callType      startTime  ...     cmdb_id  serviceName\n",
              " 0            JDBC  1588521600062  ...  docker_006       db_003\n",
              " 1            JDBC  1588521600065  ...  docker_006       db_003\n",
              " 2            JDBC  1588521600071  ...  docker_008       db_003\n",
              " 3            JDBC  1588521600072  ...  docker_006       db_003\n",
              " 4            JDBC  1588521600073  ...  docker_006       db_003\n",
              " ...           ...            ...  ...         ...          ...\n",
              " 18991909     JDBC  1588607985398  ...  docker_002       db_009\n",
              " 18991910     JDBC  1588607985400  ...  docker_002       db_009\n",
              " 18991911     JDBC  1588607985402  ...  docker_002       db_009\n",
              " 18991912     JDBC  1588607985403  ...  docker_002       db_007\n",
              " 18991913     JDBC  1588607985406  ...  docker_002       db_007\n",
              " \n",
              " [18991914 rows x 9 columns]]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 296
        },
        "id": "mFwY5f1NB9FK",
        "outputId": "befecc50-92cb-452f-acb4-bbc5ee3f3207"
      },
      "source": [
        "# generate(host,service) pairs\r\n",
        "datasets[0].plot('startTime', 'elapsedTime')"
      ],
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f1afb341c50>"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYMAAAEGCAYAAACHGfl5AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3deXxcZd3//9eHRZB9sfJTwDu9FZGtFCgFvV3AsrlSZbH+XKqieAuKoN5YlF2qIAgKaKFCLWhZSgGptLSFLrR0T/edpmtSuqRJkzZtkmb5fP+YM+k0mUlmy8zJ5P18PProzHWWuebknPlc27mOuTsiItK9HZDvDIiISP4pGIiIiIKBiIgoGIiICAoGIiICHJTvDKTrAx/4gBcVFeU7GyIiXca8efO2u3uPeMu6bDAoKiqiuLg439kQEekyzGxDomVqJhIREQUDERFRMBAREbpwn0E8DQ0NlJWVUVdXl++sdGuHHnooJ510EgcffHC+syIiSSqoYFBWVsaRRx5JUVERZpbv7HRL7k5FRQVlZWX07Nkz39kRkSQVVDNRXV0dxx9/vAJBHpkZxx9/vGpnIl1MQQUDQIEgBPQ3EOl6Ci4YiIiEVUNTMyOLS2luDt+jAxQMcqCoqIjt27fn/HMvuugiiouLueCCC+jduzcf+chH6NGjB71796Z3797MmDGDq6++Ouf5Eumunpq2jltHLWbUvLJ8Z6WNgupAlvhmz54NwPDhwykuLubxxx9vWfapT30qX9kS6XYqd9cDUFW7N885aUs1gyz717/+Rd++fenduzc//vGPaWpq2m95//79Oe+88zjjjDMYOnRoS/oRRxzBLbfcwhlnnEG/fv0oLy8H4NFHH+X000+nV69eDBgwAIDdu3fzgx/8gL59+3LOOefw2muvAVBbW8uAAQM47bTT+NrXvkZtbW27eV2/fj1nnnkmEAkU/fv359JLL6WoqIjHH3+chx9+mHPOOYcLL7yQyspKANasWcMVV1zBeeedx2c+8xlWrlyZnQMnInlVsDWDe/6zjOXv7czqPk//8FHc9ZUzEi5fsWIFL774ItOnT+fggw/mhhtuYMSIEfutM2zYMI477jhqa2s5//zzueqqqzj++OPZvXs3ffr04ZFHHuHee+/lnnvu4fHHH+f+++9n3bp1HHLIIVRVVQEwePBgPv/5zzNs2DCqqqro27cvl1xyCU8++SSHHXYYK1asYPHixZx77rkpfb+lS5eyYMEC6urq+NjHPsYDDzzAggULuOWWW3j22We5+eabuf7663niiSc45ZRTmD17NjfccAOTJk1K/WCKSKgUbDDIh4kTJzJv3jzOP/98IFJS/+AHP7jfOo8++iivvvoqAKWlpaxevZrjjz+eAw44gG984xsAfPvb3+brX/86AL169eJb3/oW/fv3p3///gBMmDCB0aNH89BDDwGRIbUbN25k6tSp3HTTTS3b9erVK6X8X3zxxRx55JEceeSRHH300XzlK18B4KyzzmLx4sXU1NQwY8YMrrnmmpZt6uvrU/oMEQmngg0G7ZXgO4u7M3DgQP7whz/slz58+HAApkyZwltvvcXMmTM57LDDuOiiixKOx48OzxwzZgxTp07lP//5D4MHD2bJkiW4Oy+//DKnnnpqVvN/yCGHtLw+4IADWt4fcMABNDY20tzczDHHHMPChQuz+rkikn/qM8iifv36MWrUKLZt2wZAZWUlGzbsmzG2urqaY489lsMOO4yVK1cya9aslmXNzc2MGjUKgOeee45Pf/rTNDc3U1paysUXX8wDDzxAdXU1NTU1XH755Tz22GO4R4anLViwAIDPfvazPPfcc0CkyWfx4sVZ/X5HHXUUPXv25KWXXgIiwW/RokVZ/QwRyQ8Fgyw6/fTTue+++7jsssvo1asXl156KZs3b25ZfsUVV9DY2Mhpp53GoEGDuPDCC1uWHX744cyZM4czzzyTSZMmceedd9LU1MS3v/1tzjrrLM455xxuuukmjjnmGO644w4aGhro1asXZ5xxBnfccQcAP/nJT6ipqeG0007jzjvv5Lzzzsv6dxwxYgRPP/00Z599NmeccUZL57WIJM/Dd5sB5mHMVRL69OnjrR9us2LFCk477bQ85SgzRxxxBDU1NfnORtZ05b+FSGf5/dgVDJ26ltu+8Al+/LmP5vzzzWyeu/eJt0w1AxERUTAIi0KqFYhI11NwwaCrNnsVEv0NRLqeggoGhx56KBUVFfoxyqPo8wwOPfTQfGdFRFJQUPcZnHTSSZSVlbVM5SD5EX3SmYh0HR0GAzMbBnwZ2ObuZwZpxwEvAkXAeuBad99hkTul/gJ8EdgDfM/d5wfbDARuD3Z7n7s/E6SfBwwH3g+MBX7uaRbtDz74YD1dS0RCL4xtF8k0Ew0HrmiVNgiY6O6nABOD9wBfAE4J/l0PDIGW4HEXcAHQF7jLzI4NthkC/Chmu9afJdKuxqZmBo9Zzo7d4ZsJUiRWmB/71GEwcPepQGWr5CuBZ4LXzwD9Y9Kf9YhZwDFm9iHgcuBNd6909x3Am8AVwbKj3H1WUBt4NmZfIkkZt2wLf5+2jt+NWZ7vrIh0Wel2IJ/g7tFba7cAJwSvTwRKY9YrC9LaSy+Lkx6XmV1vZsVmVqx+AYlqCp4a1dgUxsq3SNeQ8WiioESfk6vQ3Ye6ex9379OjR49cfKSISLeQbjDYGjTxEPy/LUjfBJwcs95JQVp76SfFSRcRkRxKNxiMBgYGrwcCr8Wkf9ciLgSqg+ak8cBlZnZs0HF8GTA+WLbTzC4MRiJ9N2ZfIiKSI8kMLX0euAj4gJmVERkVdD8w0syuAzYA1warjyUyrLSEyNDS7wO4e6WZ/Q6YG6x3r7tHO6VvYN/Q0jeCfyIiBSuM98V2GAzc/ZsJFvWLs64DNybYzzBgWJz0YuDMjvIhItLlhXhsaUFNRyEiIulRMBAREQUDERFRMBARERQMREQEBQMRkZzzEM5bqmAgIpIjFuKxpQoGIiKiYCAiIgoGIiKCgoGIiKBgICIiKBhIAQjjDJCdZeySzby2UI/86OrCeM52OGupSNhFx2xbeEftZc0NI+YDcGXvhE+HlRAL8zmqmoEUjBBfZyKhp2AgIiIKBiIiomAgIiIoGIiICAoGIiKCgoGISM6EecSbgoGIiCgYiIiIgoGIiKBgICIiKBiIiAgKBiIiOechnLY0o2BgZreY2TIzW2pmz5vZoWbW08xmm1mJmb1oZu8L1j0keF8SLC+K2c9tQfoqM7s8s68kIhJOBTlrqZmdCNwE9HH3M4EDgQHAA8Aj7v4xYAdwXbDJdcCOIP2RYD3M7PRguzOAK4C/mdmB6eZLRERSl2kz0UHA+83sIOAwYDPweWBUsPwZoH/w+srgPcHyfmZmQfoL7l7v7uuAEqBvhvkSEZEUpB0M3H0T8BCwkUgQqAbmAVXu3hisVgZEn8JxIlAabNsYrH98bHqcbfZjZtebWbGZFZeXl6ebdRERaSWTZqJjiZTqewIfBg4n0szTadx9qLv3cfc+PXr06MyPkjxbuqmaqj17850NkW4jk2aiS4B17l7u7g3AK8D/AMcEzUYAJwHRB7ZuAk4GCJYfDVTEpsfZRrqpLz/2DlcNmZHUuiEcmCHS5WQSDDYCF5rZYUHbfz9gOTAZuDpYZyDwWvB6dPCeYPkkj4yvGg0MCEYb9QROAeZkkC8pEGvKdye1XjQYWJiHaojECGMB5qCOV4nP3Web2ShgPtAILACGAmOAF8zsviDt6WCTp4F/mlkJUElkBBHuvszMRhIJJI3Aje7elG6+pPtSKJCwsxCfpWkHAwB3vwu4q1XyWuKMBnL3OuCaBPsZDAzOJC8iIpI+3YEsIiIKBiIiomAgIiIoGIiICAoGIiI5F8KRpQoGIiK5EuZbYRQMREREwUBERBQMRLqlDRW7eWra2nxnQ0IkozuQRaRrGjB0Fpur67j2/JM56tCD850dCQHVDES6oZq6xo5Xkm5FwUBEJMfCOGupgoGISI6EeGSpgoFIdxTCgqnkmYKBSDcW5pKq5JaCgXR5KuWKZE7BQAqHirkiaVMwkHZdPWQGd49elu9stMvDODQj5HTMpDUFA2lX8YYdDJ+xPt/ZSEqYny8bVhbmmdMKmIewcVPBQKQbUw0hx0IcfBUMRLoh1QikNQUDkW5INQJpTcEgB3bs3kvRoDG8sWRzvrMish/VECRKwSAHSsprAHj6nXV5zolIYdu2q66l1lNd20DRoDH8Y7quu2QoGIhIQVhSVk3fwRMZWVwKwJbqOgCen7Mxn9nqMhQMRLqhQuwxeHfrLgBmr63Mc046FsYuGwUDkW5MPQa5FebjnVEwMLNjzGyUma00sxVm9kkzO87M3jSz1cH/xwbrmpk9amYlZrbYzM6N2c/AYP3VZjYw0y8lIhLGG7vCLNOawV+Ace7+CeBsYAUwCJjo7qcAE4P3AF8ATgn+XQ8MATCz44C7gAuAvsBd0QBSaHRqiuTGotKqlqe56c705KT9DGQzOxr4LPA9AHffC+w1syuBi4LVngGmAL8GrgSe9UhX/6ygVvGhYN033b0y2O+bwBXA8+nmLWx0KkrYhLHNOlPRr9TQ7Fz51+kcc5ie7ZyKTGoGPYFy4B9mtsDMnjKzw4ET3D06oH4LcELw+kSgNGb7siAtUbqISMqag0hXtachzznpWjIJBgcB5wJD3P0cYDf7moQACGoBWSuDmNn1ZlZsZsXl5eXZ2q1I1lz68Nv0HfxWvrPRId1rJq1lEgzKgDJ3nx28H0UkOGwNmn8I/t8WLN8EnByz/UlBWqL0Ntx9qLv3cfc+PXr0yCDrIp1j9bYatu2qz3c2JOTC2EqXdjBw9y1AqZmdGiT1A5YDo4HoiKCBwGvB69HAd4NRRRcC1UFz0njgMjM7Nug4vixIKziaD0bCojudimGqBYUpL62l3YEc+BkwwszeB6wFvk8kwIw0s+uADcC1wbpjgS8CJcCeYF3cvdLMfgfMDda7N9qZXCiiJ0A3uv6kiwjzj1OqVNjKTEbBwN0XAn3iLOoXZ10Hbkywn2HAsEzyEm4FdMWFkH4CJJautvToDmQpGIVUyu0ufvf6ci5+aEpW96mZWNOTaTORSP6patBldcZMvq1DgYJDclQzyCE1aXYuXfLJ01QN0pqCQQ6oYCJhlcpUDUs3VbNtZ10n5kbyScFARJLy5cfeyXr7fjZ1qbpOCJsJFAySUL6rnupa3douhSfV5qLde5s6KSfZ07omHqaKeZgnzVMwSML5g9/igt+Hf4oBEZF0KRgkqa6hOeN9hK9iKFJ4wlv2DjcFgxzQySmSOxpKmh4Fg1wKYaeRSMHQ5ZURBYMcUElFwqaQyyVtbzrLSza6HAUDEQGgqdkprdyT72xkXRiDQRhjsYKBiADw0IRVfOaPk9lUVZvvrBSsMAamKAWDHApjaUAkakbJdiByX02XFuIf3DBTMMgBnZsSNoVYMIneQNf6xq4w3+gVJgoGInm2assuNleraSZbwtwUE2aawlokzy7/81QA1t//pZx/diGPKpLUqGYg0g2p8CytKRjkkEphnUNz86euOx2xMDYbhfG3QMEgB8J4MhYiHefuLfoDG+bTIMx5UzAINDY1U7JtV76z0Wl+9dIiigaNyXc2JAP1jeGfPjoMslkomLJqG3v2NmZvhyGmYBB4aMK7XPLwVNZt391pn5HP5oxR88ripq/asosX527McW4kVYtKqzj19nH5zkZoNTU7SzZVA9kbSrpu+26+94+53DpqcVb2F3YaTRQoXl8JwPaaenp+4PCs7jvM45yjI1m+cf5H8pyT9IWx/TXb5m3YkXDZK/PLOMCM/uecmPwOC+yY/eWtdxkxO36hJt2rb3d9pEbQmQXEMFHNIAV7G5sZWVxKc3N6V1Kh/GjV1DeysSKzOWzcnTeWbKaxKbPnRDQ3O4NeWQLkL+hOWLaFF+akVruav3EHnqUT4hcjF3Hziwuzsq+uaul7OxMvVGdSUhQMUjBkyhpuHbWY0YveS2m7QjoXR84t5XN/nMxnH5yc0nan3v4G3xw6q+X9mCWb+cmI+Qydtjaj/Oyqy3977vX/nNcSkJLx1vKtfP1vMxKWZMNu6866fGchJU3NzXz9b9N5Z/X2tLYvlEJcRxQMUlCxOzJnS1ieh7yrroHLH5nKsveqc/J5e/Y2cuvLi6nYvTflbesbm5m5tqLl/fZg/put1V3rh6W1Hz1bHDe9aNAYFmyM37SzIZgZdE15TaflKxMVNfVMXrkt4fLfvro0h7lJTmwtq3Xha/uuvczfWMUvX0qv9pSNWLB1Z91+zU1hHA6tYNCFzVlXyaqtu7jnP8vbbVPOljRbxwrCuKVbePqddW3S31y+td1t4kln1Fq2a5ft/Rhd90wx3x8+l7qGRKOXOudEyGRKjs7IUTaP+QW/n8jFD00JdSuBgkEr7rC8vfZHYG15DUWDxvDXySVZ/ezPPTiZG0fMb5O+oWI3/5q1IeF2c9ZVctWQGVTtSb3EHsvdmbu+km276nhw/Mq0+0YK0f/+ax6/e315Vvb1/JzSrOwnG7L9F172XjVFg8awqLQqpe1eW7iJT/5hEjPXVHS8copy+QNcUVPPb19d0iWHAWccDMzsQDNbYGavB+97mtlsMysxsxfN7H1B+iHB+5JgeVHMPm4L0leZ2eWZ5ikTry4o44uPTmu3xLewLNIs8+D4VSl1Ana06oaKPYxZsrlN+lVDZnL7v5eyt7H9ztaOlnfkhbmlXPPETPoOnshfJ69h9rrKpLarqKmnaNAYXg6Gr64pr+G5FNrDN1XV8ukHJmke/Sx4ZX4Zvxy5qMP1OquzfdKKSPNSe9dPPAs2RoLHyi2RgtgD41aG5r6YVK7xP7yxkhGzN/L6os0t29bU579fKxnZqBn8HFgR8/4B4BF3/xiwA7guSL8O2BGkPxKsh5mdDgwAzgCuAP5mZgdmIV9pWbUlUoWP154b7/KZmmanVEeamp1/zdpAQ1Mz1bWZlfiTtbbVd072IlhfEWkL/WVwY9tXHnuH37yafIfqi3M2UrajllHF8e+FCJOwX9i/GLmIl+eH/zh2ZMiUNS2v9+xtbBnmmUgyp6p7pJ/tgXEraUhiFFs6AbN1bfrpd9Zx5l3jU95P7P5y0QQMGQYDMzsJ+BLwVPDegM8Do4JVngH6B6+vDN4TLO8XrH8l8IK717v7OqAE6JtJvnKpo5M0Xc/N2cjt/17KsDjt1InsrEuuY3vF5p08+fYafpvCD3Yq9uzdV0WuqKnv3OammOv1xeLMm1+emraWbz01K+Hy9i7szjoXIFzTGKzauotZa1NvztlZ18CcdZX0unt8wpsg4zn7ngmc0cEPauwZtnvv/k000WO3bVc9D41fxZApa3h1waY2+6iubWgpDEJ6zUutz/QJy5KrId32ypK4x2TY9HVcNWQG01aXp56ZFGVaM/gzcCsQDbPHA1XuHr0qyoDonTAnAqUAwfLqYP2W9Djb7MfMrjezYjMrLi/P7sGJ/hGjD6+PV9LI5YPto0Eg9qlTHY1AuOThqbySRKnwS49Oa6nOxmrznWO+7qaqWsYu3r8Jq7nZGVlcSkNT/Hxt21XHefe9xcNvvpswL6PmlYVqXMV9Y1YwvSS9duuOfrByqaNaXSajWUoraxkwNH7ALK9J/JS0Hz1TzLVPzmRnXWNK06MkOr8S+U+rod+x12190JTaFKeA8o0nZ7bchBkrnaGlqf5UPD9nI796qW3z3rtbI8HpvRw0oaYdDMzsy8A2d5+Xxfy0y92Hunsfd+/To0ePTvmMpP6GscPYgv931zfytyklcU+yWJNXbqNo0Biqaxt4qbiU6SXbGbO4bT9BdBjajj0NKVVXp767f5Csa2hq88OQbEH91fn7Sk9f/9t0bn15/9vy/71wE7eOWswTb69pvSkAxesj1duJcYYpRvMQW4oL20iLf85cz5Y4Q19Hzi3l7HsmZKXGk0w/z6MTV3P3fzruvH4rpp1+foJhrZ3t2ZmRgQ7b4wSFZR0MzMhEqjfw7a5vbHPdrdyy/yiv9s7HHbv3JtVJ/m6CkWOx2f1cgnt24h3DzpRJzeB/gK+a2XrgBSLNQ38BjjGz6DQXJwHRX5RNwMkAwfKjgYrY9Djb5E27N9bEOUv+OG4lfxy3irFxOoCjHHg8GIE0c812/m/UYr711GxufK7tCKJs2Larjk/cMY6npnXc1LR1Zx1bWn3nl2KqrVt3tj0xo/dbVNTE79O4Ic7IqJr6Rq59cmbCAJKpd9Nswmht28467nhtGd/7x5w2y37z6hKqaxvY3dEEZkkEt2T6INqrWcX6Ycw9D/GaxBuamqlt1YRy5l3jmbwq8T0FEJkgL95kbbvaaZZszPFd+is2pxZo7huzghufm59wu6Zmp75h30Gsrm2g970TmBtMW3PNkzO58q/T22wXDUrRn4iqPfsfo4cmRP6Wlbv3toz+2xDnbv633y2nz31vtTRn/XtBaje6piPtYODut7n7Se5eRKQDeJK7fwuYDFwdrDYQeC14PTp4T7B8kkeO3GhgQDDaqCdwCtD2Csyx4TPWJ1wW7xrfFVzU9XFKetETI7b0ks7FklQnWczr96oiP+6vL+74RLrg9xN5PU4NJRmplOjPvGs8c9ZVsi22+Ssm041NzZRWpj/VxWWPTE3YhBHrmidmtNtM0RRkqvXFDPv+dmfdPSHNXO4Te+hSeRB90aAxzE4x6F375ExOu7PtZHevzG+/7HX5I1M5/c62TWCtA0t7Vm7Z2W7ga7lG2tnH36YkHsq9PUGBJHbfEBkxF2tPnO+wqaqWj/5mbMuP/bvbdrGwtIqqPQ08OnE1ACXb4t8w2NLc3EFJ4IW5pfS+9824hQ2AhcHoqmgT2cy1Fe3c95EdnXGfwa+BX5hZCZE+gaeD9KeB44P0XwCDANx9GTASWA6MA25095wO0nX3NhG93fVjXiezfrwTI9mO4ekl29mb4fw9i8o69w7lxVnavwF/HL+Kz/xxX7W5demzbMceFqY4hj2eues7vxnlybfXJrwLOSr2/LlqyIyW16WVe7hu+Nx2f3C/MXQWry2M/0P+9rttS/vR4ZtFg8Yk1Q4fDdLrM5iHqmzHHoZMWcOf31zd7nojgx/p372+PGGTzx/HrUrrB7FsR+L29n8v2MTfp+4/Jcrbq/ZvanWH0Qs7p2Q+pdVnfXfYnIR3te+qa2RDxe5Ou4chK8HA3ae4+5eD12vdva+7f8zdr3H3+iC9Lnj/sWD52pjtB7v7R939VHd/Ixt5SsU1T8xkfnChxEb86EymUcmWgJuand+PXcGmqlqKBo3h8cmRC2FvY3PLiR79vI60brrpyJvLt/LqgjIqaur5yb/aduekUvrsSLIVgo6q8LGdma3njznr7gn7DQP89AOT6R9TPW/vb/KnCauYsGz/u4BTbeffsrOOigzabmM76WeuqdivSWZvY/N+cyttjKkR/eGNFUxcuY1J7UwLAfDzF+JPsfBSCIbpbq+p59MPTOaBcSs7vIcktu9oR0xtLFuT+SXyz1kbGDx2RYfrTQ1G82yv2ctXH38n4XrR7I5buqXdJuOEn/NuecJ7NGrqG/ncg1O47eXOGQXYbe9Ado+MhKlvbKI4Zhxv7Il49RMz427bXsfR3sZmZq2tYOjUtfw06AsYuyTyg7R2++6EQSD2pE9009An7hjXkudEs33u2dvELS8u4rFJJWyO0/l5/uC3EuY9Vdm+xyLRD/vEFandwBT12KQSrv/nvoC4sLSK//7NWKaX7Mt3ouAQW5ubmYU+iN++uoRv/n0W3//H3Ja0EbM37lcLinL3lnMmXdt21VNauYdTb3+D4vWVebmb/Non910/G1No+puzLvHxrmto4p+zNrB0U+fVduN1vkcLUSs279yvJjxxxdZIgW/Saip3721pdhq3bEvcPrNMPBHcezGtpHPubeqWzzOYUbKd//+p2UDmk4VF276jbZaxN1u1Vz1t7e7Ry1pet3fT0K2jFrc8bOPpgX0Srtden0e2dFRqTdZfJ0dO8mjnWms74rTbRyVTcNxZ18BRhx7c0rEcO+LqzxNX84tLP55CbtOTygyl0RE5mRo8ZgX1jc08OXVtyncEJ6O2oYmLHpxMfWMzm6vreOq7+85HA9aW75uYLZXJHdubFfiSh6e2jLJZf/+XcHdqs9yWnso9ENc9E2nSeWjCuwnP33TMWd82IGbjPpr2dMuawU0xVetEI2Hiidf2f+dry3hn9fY2QzohtSaZZ9L4AUh2lElXd1uc6aGraxvafRZCbO2trlW7+4KY2ll0OObMNRX7dVxna5jre1W1PJ/isw5enJvbuYtS7YiO+vXLi1lfsaelBvpczPeckcEcQ0s37WtWbD1UO3a45XtVtfS8bWzczu2uLt17XTLRLWsG6Ur0A/Htp2fnNiOBzhy3HXZn39P+SJ722mvnrG8759I3/554BFIm8/jMWFOR8g/j8pg+liFvpz8ZYrI3lm1LUGipa2ji/e9LPDPMrLX7H8fYezIymWcqNt/XPBm/qRbYr7kvU11xYrls6/bBIJk5SiT//jq5hEMOSr4iW9xqPpfFZVXc/8bKNust37yTHwyf2yY9dm6cfN4MF1tKTtX4YCqEdLN/zu/e5O/fTdwU2dryFMf6J1JauS+QLGhnoMVbafYlxXPT8wuytq+uqlsGg9iq5msdDBl7bGL7Q+IkNx4cvyql9VtP7nVtOyXMeH0fuehzCZt4Q5ATDXMMg/FJzvuT6311Vd0yGKTiT92kXb6Q9f39xIy2D9ksGSmbkETnceshuBJe2RweHqtbdiCnK96TrqTwxetj6Cz5aruel6e5jCQ8ul0w6IwnKUlh+8f09Tn7rFNvbztdRC48+fbajleSgtbtgkGi2/dFRLqzbhcMRESkLQUDERHpfsFAD10XEWmr2wWDaZ30AHsRka6s2wUDERFpS8FAREQUDERERMFARERQMBARERQMREQEBQMREUHBQEREUDAQEREUDEREBAUDERFBwUBERFAwEBERMggGZnaymU02s+VmtszMfh6kH2dmb5rZ6uD/Y4N0M7NHzazEzBab2bkx+xoYrL/azAZm/rVERCQVmdQMGoFfuvvpwMrdrdgAAAuPSURBVIXAjWZ2OjAImOjupwATg/cAXwBOCf5dDwyBSPAA7gIuAPoCd0UDiIiI5EbawcDdN7v7/OD1LmAFcCJwJfBMsNozQP/g9ZXAsx4xCzjGzD4EXA686e6V7r4DeBO4It18iYhI6rLSZ2BmRcA5wGzgBHffHCzaApwQvD4RKI3ZrCxIS5Qe73OuN7NiMysuLy/PRtZFRIQsBAMzOwJ4GbjZ3XfGLnN3BzzTz4jZ31B37+PufXr06JGt3YqIdHsZBQMzO5hIIBjh7q8EyVuD5h+C/7cF6ZuAk2M2PylIS5QuIiI5ksloIgOeBla4+8Mxi0YD0RFBA4HXYtK/G4wquhCoDpqTxgOXmdmxQcfxZUGaiIjkyEEZbPs/wHeAJWa2MEj7DXA/MNLMrgM2ANcGy8YCXwRKgD3A9wHcvdLMfgfMDda7190rM8iXiIikKO1g4O7vAJZgcb846ztwY4J9DQOGpZsXERHJjO5AFhERBQMREVEwEBERFAxERAQFAxERQcFARERQMBARERQMREQEBQMREUHBQEREUDAQEREUDEREBAUDERFBwUBERFAwEBERFAxERAQFAxERQcFARERQMBARERQMREQEBQMREUHBQEREUDAQEREUDEREBAUDERFBwUBERFAwEBERQhQMzOwKM1tlZiVmNijf+RER6U5CEQzM7EDgr8AXgNOBb5rZ6fnNlYhI9xGKYAD0BUrcfa277wVeAK7Mc55ERLqNsASDE4HSmPdlQdp+zOx6Mys2s+Ly8vK0Pujk496fXg5FRArYQfnOQCrcfSgwFKBPnz6ezj6m3fr5rOZJRKQQhKVmsAk4Oeb9SUGaiIjkQFiCwVzgFDPraWbvAwYAo/OcJxGRbiMUzUTu3mhmPwXGAwcCw9x9WZ6zJSLSbYQiGAC4+1hgbL7zISLSHYWlmUhERPJIwUBERBQMREREwUBERABzT+verbwzs3JgQwerfQDYnoPsdEU6NvHpuCSmYxNfVzou/+XuPeIt6LLBIBlmVuzuffKdjzDSsYlPxyUxHZv4CuW4qJlIREQUDEREpPCDwdB8ZyDEdGzi03FJTMcmvoI4LgXdZyAiIskp9JqBiIgkQcFAREQKKxiY2XozW2JmC82sOEh70MxWmtliM3vVzI7Jdz5zLd5xiVn2SzNzM/tAvvKXT4mOjZn9LDhvlpnZH/OZx3xIcC31NrNZ0TQz65vvfOaamR1jZqOCc2OFmX3SzI4zszfNbHXw/7H5zmc6CqrPwMzWA33cfXtM2mXApGCa7AcA3P3XecpiXsQ7LkH6ycBTwCeA81ov7w4SnDMXA78FvuTu9Wb2QXfflq885kOC4zIBeMTd3zCzLwK3uvtFecpiXpjZM8A0d38qePbKYcBvgEp3v9/MBgHHdsXfmIKqGcTj7hPcvTF4O4vIU9Qk4hHgVqBwSgTZ8RPgfnevB+hugaAdDhwVvD4aeC+Peck5Mzsa+CzwNIC773X3KuBK4JlgtWeA/vnJYWYKLRg4MMHM5pnZ9XGW/wB4I8d5CoM2x8XMrgQ2ufui/GYt7+KdMx8HPmNms83sbTM7P4/5y5d4x+Vm4EEzKwUeAm7LW+7yoydQDvzDzBaY2VNmdjhwgrtvDtbZApyQtxxmIDQPt8mST7v7JjP7IPCmma1096kAZvZboBEYkdcc5keb40KkantZnvMVBvGOzUHAccCFwPnASDP7by+kNtWOxTsuVwO3uPvLZnYtkRLyJXnNZW4dBJwL/MzdZ5vZX4BBsSu4u5tZlzxPCqpm4O6bgv+3Aa8CfQHM7HvAl4FvdbMLGoh7XD5HpJSzKGgbPgmYb2b/X94ymScJzpky4BWPmAM0E5mMrNtIcFwGAq8Eq7wUpHUnZUCZu88O3o8iEhy2mtmHAIL/u2SzYsEEAzM73MyOjL4mUupdamZXEGkX/6q778lnHvMhwXGZ6+4fdPcidy8icpKf6+5b8pjVnEt0zgD/Bi4O0j8OvI+uMytlxto5Lu8RKUgAfB5YnZ8c5kdwfZSa2alBUj9gOTCaSKAk+P+1PGQvY4XUTHQC8KqZQeR7Pefu48ysBDiESFUXYJa7/2/+splzcY9LfrMUGonOmfcBw8xsKbAXGNjNapSJjksN8BczOwioA+L1yxW6nwEjgnNkLfB9IoXqkWZ2HZFp9a/NY/7SVlBDS0VEJD0F00wkIiLpUzAQEREFAxERUTAQEREUDESkQJjZMDPbFowC62jdR4IJ9xaa2btmVpXC5/zUzEo6muDRzJpiPmN0THo/M5sfpL9jZh8L0j9iZpODu5sXB/M/dZSXcWZWZWavt0ofYWarzGxpcFwO7mhfCgYiATO72cwOS2O775nZh4PXrwYXeYmZVcf8GHzKzGZkP9cSYzhwRTIruvst7t7b3XsDj7HvZroWwd/17jibTydy5/WGDj6mNvoZ7v7VmPQhRG6A7Q08B9wepN8OjHT3c4ABwN+S+CoPAt+Jkz6CyASUZwHvB37Y0Y4UDET2uZnILJRJM7MDge8BHwZw968FF/kPicxuGf0xmOHun8p2hmWfYOqZytg0M/toUHqeZ2bTzOwTcTb9JvB8Cp+zwN3XZ5JV4k/4FzfdzA60yFT8c4Maw49j8jIR2BUnj2ODO+gdmEMSE3QW0k1nIkkL7qwdSeQiOZDI9AofBiab2XZ3v9jMhhCZm+j9wCh3vyvYdj3wInAp8DDQh8iNSLXAJ929NsFn1rj7EWZ2EXAPUEWk5DYSWAL8PPis/u6+xsx6AE8AHwl2cbO7T8/ukSh4Q4H/dffVZnYBkdL256MLzey/iEzNMqkTPvtQizwLopHILLj/DtJ/CIwNzpedRObAAribyOSAPwMOZ9+8T9cB1e5+vpkdAkw3swnuvq6jDATNQ98hcm61S8FAuqsrgPfc/UvQMj3x94GLY+bw/627Vwal/4lm1svdFwfLKtz93GDbHwK/cvdiknc2cBqRkuxa4Cl372tmPydyl+vNwF+IPD/gHTP7CDA+2EaSYGZHAJ8CXgrupobIbASxBhAJ9E3BNscDE4NlxwHvM7PolNTfcfclKWThv4LJ/v4bmGRmS9x9DXAL8MVgsrv/I1Kg+CGRGspwd/+TmX0S+KeZnUlkOpBeZnZ1sN+jgVOADoMBkeA31d2ndbSigoF0V0uAP1nkgUevu/u0mB+MqGstMn3zQcCHgNOBaDB4McPPnxud9tjM1gATYvJ1cfD6EuD0mHwdZWZHuHtNhp/dXRwAVAXNdokMAG6MvnH3CqA3tExwWeTud6fz4TGT/a01synAOWa2Ezg7ZrK7F4Ho9DDXEfR5uPtMMzuUyASJRmSm1PGpfL6Z3QX0AH7c0bqgPgPpptz9XSIzTi4B7jOzO2OXm1lP4FdAP3fvBYwBDo1ZZXeGWaiPed0c876ZfYW0A4ALY/odTlQgSJ677wTWmdk1ABZxdnR50H9wLDAz259tZscGTToEI47+h8ikdjuAoy0yASJEmhpXBK83Epn8DjM7jcj5Vk6kRviT6IggM/t40MzZ3uf/ELgc+Ka7NyeTZwUD6ZaC0T973P1fREZknEukI+7IYJWjiPzgV5vZCcAX2tld7HbZNIFIk1E0z+2VcLs9M3ueyA/7qWZWFkwc9y3gOjNbBCwj8lSyqAHAC6lOQmhmN5lZGZH+psVm9lSQ3if6mkhzXnHwuZOJ9BksD566+CPg5WDZd4D/C7b5JfCjIP154HtB3p4iEkjmW2TY7JMEBQYzm0akv6tf8J0vD/b1BJEJB2cGo9n2K+zE/V6aqE66o+CieZBISbyByKMuPwn8lEhfwsVmNpxIm3MpUA2Mdvfh1ur5wGZ2FfB7oKUDOegk/pW7fznmM2M7kFuWBU0Iv3L34thlQYnyr0R+WA4i0vbbnWbclRxSMBARETUTiYiIgoGIiKBgICIiKBiIiAgKBiIigoKBiIigYCAiIsD/AzyjDypqFZ9hAAAAAElFTkSuQmCC\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "khS_vt4-C-G6",
        "outputId": "6976bf2f-c9b6-40ef-c3bc-23c94a38a25b"
      },
      "source": [
        "for dataset in datasets:\r\n",
        "  print(dataset['elapsedTime'].describe())\r\n",
        "  dataset"
      ],
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "count    3.650205e+06\n",
            "mean     1.623221e+02\n",
            "std      3.493014e+02\n",
            "min      1.300000e+01\n",
            "25%      2.700000e+01\n",
            "50%      4.000000e+01\n",
            "75%      1.220000e+02\n",
            "max      1.093000e+04\n",
            "Name: elapsedTime, dtype: float64\n",
            "count    730041.000000\n",
            "mean        608.916603\n",
            "std         609.137235\n",
            "min         141.000000\n",
            "25%         208.000000\n",
            "50%         330.000000\n",
            "75%         755.000000\n",
            "max       10947.000000\n",
            "Name: elapsedTime, dtype: float64\n",
            "count    3.650205e+06\n",
            "mean     1.351178e+02\n",
            "std      3.394052e+02\n",
            "min      1.100000e+01\n",
            "25%      2.100000e+01\n",
            "50%      2.800000e+01\n",
            "75%      3.900000e+01\n",
            "max      5.295000e+03\n",
            "Name: elapsedTime, dtype: float64\n",
            "count    730041.000000\n",
            "mean         10.110518\n",
            "std          21.613297\n",
            "min           3.000000\n",
            "25%           5.000000\n",
            "50%           5.000000\n",
            "75%           6.000000\n",
            "max        1401.000000\n",
            "Name: elapsedTime, dtype: float64\n",
            "count    1.460082e+07\n",
            "mean     1.124013e+01\n",
            "std      2.747132e+01\n",
            "min      1.000000e+00\n",
            "25%      2.000000e+00\n",
            "50%      3.000000e+00\n",
            "75%      7.000000e+00\n",
            "max      2.389000e+03\n",
            "Name: elapsedTime, dtype: float64\n",
            "count    1.899191e+07\n",
            "mean     2.933276e+00\n",
            "std      1.089728e+01\n",
            "min      0.000000e+00\n",
            "25%      1.000000e+00\n",
            "50%      1.000000e+00\n",
            "75%      2.000000e+00\n",
            "max      1.598000e+03\n",
            "Name: elapsedTime, dtype: float64\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 80
        },
        "id": "pmWG5jUsD6yB",
        "outputId": "05515668-67ac-4205-8ef4-daff12acb056"
      },
      "source": [
        "datasets[1][datasets[1]['elapsedTime'] == 10947.000000]"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>callType</th>\n",
              "      <th>startTime</th>\n",
              "      <th>elapsedTime</th>\n",
              "      <th>success</th>\n",
              "      <th>traceId</th>\n",
              "      <th>id</th>\n",
              "      <th>pid</th>\n",
              "      <th>cmdb_id</th>\n",
              "      <th>serviceName</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>684900</th>\n",
              "      <td>OSB</td>\n",
              "      <td>1588603535225</td>\n",
              "      <td>10947.0</td>\n",
              "      <td>True</td>\n",
              "      <td>5b2e2171e0263f794360</td>\n",
              "      <td>84e90171e0263f794361</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       callType      startTime  elapsedTime  ...   pid cmdb_id serviceName\n",
              "684900      OSB  1588603535225      10947.0  ...  None  os_021     osb_001\n",
              "\n",
              "[1 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "QQppB4HyIaLC"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bh-kFJiwF9cr"
      },
      "source": [
        "from sklearn.cluster import Birch\r\n",
        "data = datasets[1]['elapsedTime'].values.reshape(-1,1)\r\n",
        "\r\n",
        "brc = Birch(n_clusters=None)\r\n",
        "brc.fit(data)\r\n",
        "brc.predict(data)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "n1mXYjS5Ib3J",
        "outputId": "a6b6ff81-bdf8-42d3-bd6d-d19b92b2ffbb"
      },
      "source": [
        "from sklearn.cluster import Birch\r\n",
        "\r\n",
        "dataset = pd.read_csv(TRACE_PATH + 'trace_osb.csv')\r\n",
        "data = dataset['elapsedTime'].values.reshape(-1,1)\r\n"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([3326, 1537, 1296, ..., 3392, 3627, 3461])"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "dhNNIJhoJL4r"
      },
      "source": [
        "brc = Birch(n_clusters=2)\r\n",
        "brc.fit(data)\r\n",
        "predictions = brc.predict(data)"
      ],
      "execution_count": 7,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "rJnGogNFJreL",
        "outputId": "6847af22-4427-425f-9d2b-bd75179143ab"
      },
      "source": [
        "for i in (0,1):\r\n",
        "  print(f'Testing values i=={i}')\r\n",
        "  print(sum(filter(lambda x: x==i, predictions)))"
      ],
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Testing values i==0\n",
            "0\n",
            "Testing values i==1\n",
            "14879\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "JYa0D2rnKA16",
        "outputId": "d3cd97a5-633d-4240-8280-05200dee5c5d"
      },
      "source": [
        "import numpy as np\r\n",
        "np.unique(predictions, return_counts=True)"
      ],
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(array([0, 1]), array([715162,  14879]))"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7tYZmK4zKfNp"
      },
      "source": [
        "TEST_DATA = '/content/drive/MyDrive/data/trace/'\r\n",
        "test_data = pd.read_csv(TEST_DATA + 'trace_osb.csv')"
      ],
      "execution_count": 15,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "id": "Z84SYwjFLDUK",
        "outputId": "f8a1f994-4864-47a5-dc27-7e42d737aba0"
      },
      "source": [
        "test_data"
      ],
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>startTime</th>\n",
              "      <th>elapsedTime</th>\n",
              "      <th>success</th>\n",
              "      <th>traceId</th>\n",
              "      <th>id</th>\n",
              "      <th>pid</th>\n",
              "      <th>cmdb_id</th>\n",
              "      <th>serviceName</th>\n",
              "      <th>callType</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1606863598104</td>\n",
              "      <td>1946.0</td>\n",
              "      <td>1</td>\n",
              "      <td>b158517262a9da185958</td>\n",
              "      <td>811d617262a9da185959</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1606863600023</td>\n",
              "      <td>269.0</td>\n",
              "      <td>1</td>\n",
              "      <td>ea67517262a9e1973758</td>\n",
              "      <td>8212017262a9e1973759</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1606863600025</td>\n",
              "      <td>363.0</td>\n",
              "      <td>1</td>\n",
              "      <td>a48f617262a9e1993888</td>\n",
              "      <td>2c18d17262a9e1993889</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1606863600023</td>\n",
              "      <td>367.0</td>\n",
              "      <td>1</td>\n",
              "      <td>8048617262a9e1973884</td>\n",
              "      <td>8f41117262a9e1973885</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1606863600028</td>\n",
              "      <td>411.0</td>\n",
              "      <td>1</td>\n",
              "      <td>6276417262a9e19b5196</td>\n",
              "      <td>38eff17262a9e19c5197</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>345616</th>\n",
              "      <td>1606899598941</td>\n",
              "      <td>457.0</td>\n",
              "      <td>1</td>\n",
              "      <td>3f1c3172623c005d6712</td>\n",
              "      <td>f9026172623c005d6713</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>345617</th>\n",
              "      <td>1606899598941</td>\n",
              "      <td>493.0</td>\n",
              "      <td>1</td>\n",
              "      <td>bdf63172623c005d5706</td>\n",
              "      <td>3d357172623c005d5707</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>345618</th>\n",
              "      <td>1606899598947</td>\n",
              "      <td>495.0</td>\n",
              "      <td>1</td>\n",
              "      <td>a8f4b172623c00638832</td>\n",
              "      <td>39a9b172623c00638833</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>345619</th>\n",
              "      <td>1606899599012</td>\n",
              "      <td>538.0</td>\n",
              "      <td>1</td>\n",
              "      <td>f602d172623c00a48838</td>\n",
              "      <td>fe5c9172623c00a48839</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>345620</th>\n",
              "      <td>1606899597678</td>\n",
              "      <td>1935.0</td>\n",
              "      <td>1</td>\n",
              "      <td>60cf6172623bfb6e6700</td>\n",
              "      <td>57fd3172623bfb6e6701</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>345621 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "            startTime  elapsedTime  success  ... cmdb_id serviceName callType\n",
              "0       1606863598104       1946.0        1  ...  os_022     osb_001      OSB\n",
              "1       1606863600023        269.0        1  ...  os_021     osb_001      OSB\n",
              "2       1606863600025        363.0        1  ...  os_021     osb_001      OSB\n",
              "3       1606863600023        367.0        1  ...  os_021     osb_001      OSB\n",
              "4       1606863600028        411.0        1  ...  os_021     osb_001      OSB\n",
              "...               ...          ...      ...  ...     ...         ...      ...\n",
              "345616  1606899598941        457.0        1  ...  os_021     osb_001      OSB\n",
              "345617  1606899598941        493.0        1  ...  os_022     osb_001      OSB\n",
              "345618  1606899598947        495.0        1  ...  os_022     osb_001      OSB\n",
              "345619  1606899599012        538.0        1  ...  os_022     osb_001      OSB\n",
              "345620  1606899597678       1935.0        1  ...  os_021     osb_001      OSB\n",
              "\n",
              "[345621 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "bOVWUncdLLcx"
      },
      "source": [
        "df = test_data['elapsedTime'].values.reshape(-1,1)"
      ],
      "execution_count": 22,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LUzubDuGLfRK"
      },
      "source": [
        "test_predictions = brc.predict(df)"
      ],
      "execution_count": 24,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "95uJltLCLm6C",
        "outputId": "56992e8e-5781-4176-b76c-03faa8cebefc"
      },
      "source": [
        "np.unique(test_predictions, return_counts=True)"
      ],
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(array([0, 1]), array([331889,  13732]))"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "qiXmNZnHMvcq"
      },
      "source": [
        "res = np.where(test_predictions == 1)"
      ],
      "execution_count": 27,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "-m9qkjk_MC_Z",
        "outputId": "79f42fdf-bf04-4840-ac51-f7833ff78f7b"
      },
      "source": [
        "test_data.iloc[res]['elapsedTime'].describe()"
      ],
      "execution_count": 31,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "count    13732.000000\n",
              "mean      3886.723711\n",
              "std       3246.729089\n",
              "min       2380.000000\n",
              "25%       2589.000000\n",
              "50%       2925.500000\n",
              "75%       3779.000000\n",
              "max      58507.000000\n",
              "Name: elapsedTime, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "id": "MzgU1VufNd3Z",
        "outputId": "e7fba805-74b1-4c37-ba4c-6f1e3a53d5b9"
      },
      "source": [
        "small_trace = pd.read_csv(TEST_DATA + 'small_trace.csv')\r\n",
        "small_trace = small_trace[small_trace['callType'] == 'OSB']\r\n",
        "small_trace"
      ],
      "execution_count": 32,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Unnamed: 0</th>\n",
              "      <th>startTime</th>\n",
              "      <th>elapsedTime</th>\n",
              "      <th>success</th>\n",
              "      <th>traceId</th>\n",
              "      <th>id</th>\n",
              "      <th>pid</th>\n",
              "      <th>cmdb_id</th>\n",
              "      <th>serviceName</th>\n",
              "      <th>callType</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>88970</th>\n",
              "      <td>132792</td>\n",
              "      <td>1606862520032</td>\n",
              "      <td>246.0</td>\n",
              "      <td>1</td>\n",
              "      <td>0e8ff172629966e06140</td>\n",
              "      <td>ed12f172629966e06141</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>88971</th>\n",
              "      <td>132793</td>\n",
              "      <td>1606862520081</td>\n",
              "      <td>286.0</td>\n",
              "      <td>1</td>\n",
              "      <td>2f6c1172629967115222</td>\n",
              "      <td>39fc6172629967115223</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>88972</th>\n",
              "      <td>132794</td>\n",
              "      <td>1606862520082</td>\n",
              "      <td>375.0</td>\n",
              "      <td>1</td>\n",
              "      <td>7d96a172629967125224</td>\n",
              "      <td>1b7d9172629967125225</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>88973</th>\n",
              "      <td>132795</td>\n",
              "      <td>1606862520202</td>\n",
              "      <td>282.0</td>\n",
              "      <td>1</td>\n",
              "      <td>c5f92172629967895562</td>\n",
              "      <td>6f2911726299678a5563</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>88974</th>\n",
              "      <td>132796</td>\n",
              "      <td>1606862520090</td>\n",
              "      <td>481.0</td>\n",
              "      <td>1</td>\n",
              "      <td>12ff7172629967198352</td>\n",
              "      <td>793191726299671a8353</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91384</th>\n",
              "      <td>135206</td>\n",
              "      <td>1606862792531</td>\n",
              "      <td>604.0</td>\n",
              "      <td>1</td>\n",
              "      <td>e3e13172629d8f537368</td>\n",
              "      <td>e4037172629d8f537369</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91385</th>\n",
              "      <td>135207</td>\n",
              "      <td>1606862792592</td>\n",
              "      <td>544.0</td>\n",
              "      <td>1</td>\n",
              "      <td>9b874172629d8f907032</td>\n",
              "      <td>b8749172629d8f907033</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91386</th>\n",
              "      <td>135208</td>\n",
              "      <td>1606862792675</td>\n",
              "      <td>572.0</td>\n",
              "      <td>1</td>\n",
              "      <td>ab7a3172629d8fe31164</td>\n",
              "      <td>a41aa172629d8fe31165</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91387</th>\n",
              "      <td>135209</td>\n",
              "      <td>1606862792539</td>\n",
              "      <td>710.0</td>\n",
              "      <td>1</td>\n",
              "      <td>e87f1172629d8f5b7026</td>\n",
              "      <td>90410172629d8f5b7027</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91388</th>\n",
              "      <td>135210</td>\n",
              "      <td>1606862792566</td>\n",
              "      <td>770.0</td>\n",
              "      <td>1</td>\n",
              "      <td>c37fb172629d8f761152</td>\n",
              "      <td>52a5c172629d8f761153</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>2419 rows × 10 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       Unnamed: 0      startTime  elapsedTime  ...  cmdb_id serviceName callType\n",
              "88970      132792  1606862520032        246.0  ...   os_021     osb_001      OSB\n",
              "88971      132793  1606862520081        286.0  ...   os_022     osb_001      OSB\n",
              "88972      132794  1606862520082        375.0  ...   os_022     osb_001      OSB\n",
              "88973      132795  1606862520202        282.0  ...   os_022     osb_001      OSB\n",
              "88974      132796  1606862520090        481.0  ...   os_022     osb_001      OSB\n",
              "...           ...            ...          ...  ...      ...         ...      ...\n",
              "91384      135206  1606862792531        604.0  ...   os_022     osb_001      OSB\n",
              "91385      135207  1606862792592        544.0  ...   os_022     osb_001      OSB\n",
              "91386      135208  1606862792675        572.0  ...   os_022     osb_001      OSB\n",
              "91387      135209  1606862792539        710.0  ...   os_022     osb_001      OSB\n",
              "91388      135210  1606862792566        770.0  ...   os_022     osb_001      OSB\n",
              "\n",
              "[2419 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 32
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "eR4-fGzENnr6",
        "outputId": "40a79f34-b047-46b2-dd34-6463163be06e"
      },
      "source": [
        "%%time\r\n",
        "small_data = small_trace['elapsedTime'].values.reshape(-1,1)\r\n",
        "small_predictions = brc.predict(small_data)"
      ],
      "execution_count": 40,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "CPU times: user 56.3 ms, sys: 8.02 ms, total: 64.3 ms\n",
            "Wall time: 63.8 ms\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "50P7MMZJNy2C",
        "outputId": "a2fe5414-9a88-4420-d075-155acc17d84c"
      },
      "source": [
        "np.unique(small_predictions, return_counts=True)"
      ],
      "execution_count": 34,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(array([0, 1]), array([2369,   50]))"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 34
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "2Lt5o3dvN5Gx",
        "outputId": "685cffdc-0176-40f7-d6ac-6a404e9d16e7"
      },
      "source": [
        "sres = np.where(small_predictions == 1)\r\n",
        "small_trace.iloc[sres]"
      ],
      "execution_count": 36,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Unnamed: 0</th>\n",
              "      <th>startTime</th>\n",
              "      <th>elapsedTime</th>\n",
              "      <th>success</th>\n",
              "      <th>traceId</th>\n",
              "      <th>id</th>\n",
              "      <th>pid</th>\n",
              "      <th>cmdb_id</th>\n",
              "      <th>serviceName</th>\n",
              "      <th>callType</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>89329</th>\n",
              "      <td>133151</td>\n",
              "      <td>1606862540893</td>\n",
              "      <td>2470.0</td>\n",
              "      <td>1</td>\n",
              "      <td>ee4051726299b85d6530</td>\n",
              "      <td>099301726299b85d6531</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89330</th>\n",
              "      <td>133152</td>\n",
              "      <td>1606862540794</td>\n",
              "      <td>2571.0</td>\n",
              "      <td>1</td>\n",
              "      <td>5597b1726299b7fa6524</td>\n",
              "      <td>94d981726299b7fa6525</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89331</th>\n",
              "      <td>133153</td>\n",
              "      <td>1606862540898</td>\n",
              "      <td>2576.0</td>\n",
              "      <td>1</td>\n",
              "      <td>62ca21726299b8627836</td>\n",
              "      <td>33b471726299b8627837</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89459</th>\n",
              "      <td>133281</td>\n",
              "      <td>1606862580086</td>\n",
              "      <td>2779.0</td>\n",
              "      <td>1</td>\n",
              "      <td>aae95172629a51768700</td>\n",
              "      <td>a7c5c172629a51768701</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89460</th>\n",
              "      <td>133282</td>\n",
              "      <td>1606862580101</td>\n",
              "      <td>2765.0</td>\n",
              "      <td>1</td>\n",
              "      <td>37c21172629a51858704</td>\n",
              "      <td>08147172629a51858705</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89469</th>\n",
              "      <td>133291</td>\n",
              "      <td>1606862580411</td>\n",
              "      <td>3081.0</td>\n",
              "      <td>1</td>\n",
              "      <td>04f04172629a52bb8712</td>\n",
              "      <td>2029c172629a52bb8713</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89695</th>\n",
              "      <td>133517</td>\n",
              "      <td>1606862595704</td>\n",
              "      <td>2571.0</td>\n",
              "      <td>1</td>\n",
              "      <td>a209c172629a8e788106</td>\n",
              "      <td>48c63172629a8e788107</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89701</th>\n",
              "      <td>133523</td>\n",
              "      <td>1606862595795</td>\n",
              "      <td>2984.0</td>\n",
              "      <td>1</td>\n",
              "      <td>84374172629a8ed36812</td>\n",
              "      <td>44467172629a8ed36813</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89704</th>\n",
              "      <td>133526</td>\n",
              "      <td>1606862595998</td>\n",
              "      <td>2982.0</td>\n",
              "      <td>1</td>\n",
              "      <td>3708e172629a8f9e6760</td>\n",
              "      <td>e6668172629a8f9e6761</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89705</th>\n",
              "      <td>133527</td>\n",
              "      <td>1606862596201</td>\n",
              "      <td>2781.0</td>\n",
              "      <td>1</td>\n",
              "      <td>650b4172629a90696766</td>\n",
              "      <td>31f43172629a90696767</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89706</th>\n",
              "      <td>133528</td>\n",
              "      <td>1606862596302</td>\n",
              "      <td>2703.0</td>\n",
              "      <td>1</td>\n",
              "      <td>4fe05172629a90ce6674</td>\n",
              "      <td>c0f80172629a90ce6675</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89708</th>\n",
              "      <td>133530</td>\n",
              "      <td>1606862595999</td>\n",
              "      <td>3075.0</td>\n",
              "      <td>1</td>\n",
              "      <td>94373172629a8f9f8118</td>\n",
              "      <td>711c2172629a8f9f8119</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89777</th>\n",
              "      <td>133599</td>\n",
              "      <td>1606862601709</td>\n",
              "      <td>2402.0</td>\n",
              "      <td>1</td>\n",
              "      <td>b1b05172629aa5ed6728</td>\n",
              "      <td>9b659172629aa5ed6729</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89867</th>\n",
              "      <td>133689</td>\n",
              "      <td>1606862607029</td>\n",
              "      <td>2799.0</td>\n",
              "      <td>1</td>\n",
              "      <td>5dc3e172629abab56782</td>\n",
              "      <td>a9bf2172629abab56783</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89878</th>\n",
              "      <td>133700</td>\n",
              "      <td>1606862606812</td>\n",
              "      <td>3513.0</td>\n",
              "      <td>1</td>\n",
              "      <td>e4f1a172629ab9dc8220</td>\n",
              "      <td>a884c172629ab9dc8221</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89885</th>\n",
              "      <td>133707</td>\n",
              "      <td>1606862608209</td>\n",
              "      <td>2509.0</td>\n",
              "      <td>1</td>\n",
              "      <td>3390b172629abf516886</td>\n",
              "      <td>30c65172629abf516887</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89900</th>\n",
              "      <td>133722</td>\n",
              "      <td>1606862609238</td>\n",
              "      <td>2471.0</td>\n",
              "      <td>1</td>\n",
              "      <td>51e5c172629ac3568250</td>\n",
              "      <td>8f6fb172629ac3568251</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89911</th>\n",
              "      <td>133733</td>\n",
              "      <td>1606862610298</td>\n",
              "      <td>2615.0</td>\n",
              "      <td>1</td>\n",
              "      <td>5dea6172629ac77a6954</td>\n",
              "      <td>3a51d172629ac77a6955</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89949</th>\n",
              "      <td>133771</td>\n",
              "      <td>1606862640567</td>\n",
              "      <td>2465.0</td>\n",
              "      <td>1</td>\n",
              "      <td>3ec50172629b3db76252</td>\n",
              "      <td>e1ebd172629b3db76253</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>89953</th>\n",
              "      <td>133775</td>\n",
              "      <td>1606862640397</td>\n",
              "      <td>2861.0</td>\n",
              "      <td>1</td>\n",
              "      <td>ab942172629b3d0d9072</td>\n",
              "      <td>e896c172629b3d0d9073</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90163</th>\n",
              "      <td>133985</td>\n",
              "      <td>1606862653000</td>\n",
              "      <td>3128.0</td>\n",
              "      <td>1</td>\n",
              "      <td>7490b172629b6e486438</td>\n",
              "      <td>0c7c2172629b6e486439</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90164</th>\n",
              "      <td>133986</td>\n",
              "      <td>1606862653003</td>\n",
              "      <td>3387.0</td>\n",
              "      <td>1</td>\n",
              "      <td>23a36172629b6e4b6096</td>\n",
              "      <td>b893d172629b6e4b6097</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90166</th>\n",
              "      <td>133988</td>\n",
              "      <td>1606862654046</td>\n",
              "      <td>2404.0</td>\n",
              "      <td>1</td>\n",
              "      <td>7179e172629b725d6108</td>\n",
              "      <td>d357c172629b725e6109</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90259</th>\n",
              "      <td>134081</td>\n",
              "      <td>1606862659878</td>\n",
              "      <td>2487.0</td>\n",
              "      <td>1</td>\n",
              "      <td>35179172629b89268526</td>\n",
              "      <td>348f9172629b89268527</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90264</th>\n",
              "      <td>134086</td>\n",
              "      <td>1606862660881</td>\n",
              "      <td>2393.0</td>\n",
              "      <td>1</td>\n",
              "      <td>1235f172629b8d117100</td>\n",
              "      <td>81a6e172629b8d117101</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90355</th>\n",
              "      <td>134177</td>\n",
              "      <td>1606862665890</td>\n",
              "      <td>2615.0</td>\n",
              "      <td>1</td>\n",
              "      <td>11273172629ba0a28598</td>\n",
              "      <td>9b80f172629ba0a28599</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90359</th>\n",
              "      <td>134181</td>\n",
              "      <td>1606862666347</td>\n",
              "      <td>2457.0</td>\n",
              "      <td>1</td>\n",
              "      <td>371f7172629ba26b7292</td>\n",
              "      <td>a6c43172629ba26b7293</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90360</th>\n",
              "      <td>134182</td>\n",
              "      <td>1606862666388</td>\n",
              "      <td>2425.0</td>\n",
              "      <td>1</td>\n",
              "      <td>c7262172629ba2947298</td>\n",
              "      <td>a15a2172629ba2947299</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90371</th>\n",
              "      <td>134193</td>\n",
              "      <td>1606862666681</td>\n",
              "      <td>3539.0</td>\n",
              "      <td>1</td>\n",
              "      <td>96ee6172629ba3b98610</td>\n",
              "      <td>310e1172629ba3b98611</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90372</th>\n",
              "      <td>134194</td>\n",
              "      <td>1606862667270</td>\n",
              "      <td>3055.0</td>\n",
              "      <td>1</td>\n",
              "      <td>3cb3c172629ba6067172</td>\n",
              "      <td>91b1b172629ba6067173</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90373</th>\n",
              "      <td>134195</td>\n",
              "      <td>1606862666905</td>\n",
              "      <td>3433.0</td>\n",
              "      <td>1</td>\n",
              "      <td>22d27172629ba4997258</td>\n",
              "      <td>39a1f172629ba4997259</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90423</th>\n",
              "      <td>134245</td>\n",
              "      <td>1606862700025</td>\n",
              "      <td>2404.0</td>\n",
              "      <td>1</td>\n",
              "      <td>563ca172629c25f97220</td>\n",
              "      <td>07f8e172629c25f97221</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90424</th>\n",
              "      <td>134246</td>\n",
              "      <td>1606862700025</td>\n",
              "      <td>2406.0</td>\n",
              "      <td>1</td>\n",
              "      <td>637c7172629c25f97218</td>\n",
              "      <td>99d43172629c25f97219</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90425</th>\n",
              "      <td>134247</td>\n",
              "      <td>1606862700026</td>\n",
              "      <td>2408.0</td>\n",
              "      <td>1</td>\n",
              "      <td>463f6172629c25fa7222</td>\n",
              "      <td>698c8172629c25fa7223</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90563</th>\n",
              "      <td>134385</td>\n",
              "      <td>1606862707327</td>\n",
              "      <td>2809.0</td>\n",
              "      <td>1</td>\n",
              "      <td>12798172629c427f9516</td>\n",
              "      <td>985cc172629c427f9517</td>\n",
              "      <td>None</td>\n",
              "      <td>os_022</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90699</th>\n",
              "      <td>134521</td>\n",
              "      <td>1606862716630</td>\n",
              "      <td>2645.0</td>\n",
              "      <td>1</td>\n",
              "      <td>726a1172629c66d67550</td>\n",
              "      <td>f3329172629c66d67551</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90700</th>\n",
              "      <td>134522</td>\n",
              "      <td>1606862716772</td>\n",
              "      <td>2602.0</td>\n",
              "      <td>1</td>\n",
              "      <td>358ea172629c67648862</td>\n",
              "      <td>be6ae172629c67648863</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90701</th>\n",
              "      <td>134523</td>\n",
              "      <td>1606862716768</td>\n",
              "      <td>2720.0</td>\n",
              "      <td>1</td>\n",
              "      <td>b813d172629c67607504</td>\n",
              "      <td>8dc76172629c67607505</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90703</th>\n",
              "      <td>134525</td>\n",
              "      <td>1606862717100</td>\n",
              "      <td>2477.0</td>\n",
              "      <td>1</td>\n",
              "      <td>21ffe172629c68ac7418</td>\n",
              "      <td>a01f1172629c68ac7419</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91214</th>\n",
              "      <td>135036</td>\n",
              "      <td>1606862778550</td>\n",
              "      <td>2525.0</td>\n",
              "      <td>1</td>\n",
              "      <td>a6920172629d58b69240</td>\n",
              "      <td>667c2172629d58b69241</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91227</th>\n",
              "      <td>135049</td>\n",
              "      <td>1606862779444</td>\n",
              "      <td>2528.0</td>\n",
              "      <td>1</td>\n",
              "      <td>784de172629d5c347912</td>\n",
              "      <td>ac787172629d5c347913</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91228</th>\n",
              "      <td>135050</td>\n",
              "      <td>1606862779708</td>\n",
              "      <td>2461.0</td>\n",
              "      <td>1</td>\n",
              "      <td>8ef77172629d5d3c7820</td>\n",
              "      <td>11972172629d5d3c7821</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91229</th>\n",
              "      <td>135051</td>\n",
              "      <td>1606862779880</td>\n",
              "      <td>2593.0</td>\n",
              "      <td>1</td>\n",
              "      <td>03603172629d5de87826</td>\n",
              "      <td>f7c4a172629d5de87827</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91290</th>\n",
              "      <td>135112</td>\n",
              "      <td>1606862784751</td>\n",
              "      <td>2555.0</td>\n",
              "      <td>1</td>\n",
              "      <td>6d3ac172629d70ef9312</td>\n",
              "      <td>75874172629d70ef9313</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91297</th>\n",
              "      <td>135119</td>\n",
              "      <td>1606862784806</td>\n",
              "      <td>3021.0</td>\n",
              "      <td>1</td>\n",
              "      <td>d8f56172629d71267862</td>\n",
              "      <td>6ef12172629d71267863</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91302</th>\n",
              "      <td>135124</td>\n",
              "      <td>1606862784736</td>\n",
              "      <td>3581.0</td>\n",
              "      <td>1</td>\n",
              "      <td>6df11172629d70e07954</td>\n",
              "      <td>a9c8e172629d70e07955</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91304</th>\n",
              "      <td>135126</td>\n",
              "      <td>1606862784959</td>\n",
              "      <td>3549.0</td>\n",
              "      <td>1</td>\n",
              "      <td>464ff172629d71bf7960</td>\n",
              "      <td>1950c172629d71bf7961</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91306</th>\n",
              "      <td>135128</td>\n",
              "      <td>1606862784702</td>\n",
              "      <td>4013.0</td>\n",
              "      <td>1</td>\n",
              "      <td>ae540172629d70be7948</td>\n",
              "      <td>14e1b172629d70be7949</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91309</th>\n",
              "      <td>135131</td>\n",
              "      <td>1606862785935</td>\n",
              "      <td>2980.0</td>\n",
              "      <td>1</td>\n",
              "      <td>a1148172629d758f7874</td>\n",
              "      <td>afb30172629d758f7875</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91314</th>\n",
              "      <td>135136</td>\n",
              "      <td>1606862786819</td>\n",
              "      <td>2687.0</td>\n",
              "      <td>1</td>\n",
              "      <td>8d04a172629d79038006</td>\n",
              "      <td>afe0b172629d79038007</td>\n",
              "      <td>None</td>\n",
              "      <td>os_021</td>\n",
              "      <td>osb_001</td>\n",
              "      <td>OSB</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       Unnamed: 0      startTime  elapsedTime  ...  cmdb_id serviceName callType\n",
              "89329      133151  1606862540893       2470.0  ...   os_021     osb_001      OSB\n",
              "89330      133152  1606862540794       2571.0  ...   os_021     osb_001      OSB\n",
              "89331      133153  1606862540898       2576.0  ...   os_021     osb_001      OSB\n",
              "89459      133281  1606862580086       2779.0  ...   os_022     osb_001      OSB\n",
              "89460      133282  1606862580101       2765.0  ...   os_022     osb_001      OSB\n",
              "89469      133291  1606862580411       3081.0  ...   os_022     osb_001      OSB\n",
              "89695      133517  1606862595704       2571.0  ...   os_021     osb_001      OSB\n",
              "89701      133523  1606862595795       2984.0  ...   os_021     osb_001      OSB\n",
              "89704      133526  1606862595998       2982.0  ...   os_021     osb_001      OSB\n",
              "89705      133527  1606862596201       2781.0  ...   os_021     osb_001      OSB\n",
              "89706      133528  1606862596302       2703.0  ...   os_021     osb_001      OSB\n",
              "89708      133530  1606862595999       3075.0  ...   os_021     osb_001      OSB\n",
              "89777      133599  1606862601709       2402.0  ...   os_021     osb_001      OSB\n",
              "89867      133689  1606862607029       2799.0  ...   os_021     osb_001      OSB\n",
              "89878      133700  1606862606812       3513.0  ...   os_021     osb_001      OSB\n",
              "89885      133707  1606862608209       2509.0  ...   os_021     osb_001      OSB\n",
              "89900      133722  1606862609238       2471.0  ...   os_021     osb_001      OSB\n",
              "89911      133733  1606862610298       2615.0  ...   os_021     osb_001      OSB\n",
              "89949      133771  1606862640567       2465.0  ...   os_022     osb_001      OSB\n",
              "89953      133775  1606862640397       2861.0  ...   os_022     osb_001      OSB\n",
              "90163      133985  1606862653000       3128.0  ...   os_022     osb_001      OSB\n",
              "90164      133986  1606862653003       3387.0  ...   os_022     osb_001      OSB\n",
              "90166      133988  1606862654046       2404.0  ...   os_022     osb_001      OSB\n",
              "90259      134081  1606862659878       2487.0  ...   os_021     osb_001      OSB\n",
              "90264      134086  1606862660881       2393.0  ...   os_021     osb_001      OSB\n",
              "90355      134177  1606862665890       2615.0  ...   os_021     osb_001      OSB\n",
              "90359      134181  1606862666347       2457.0  ...   os_021     osb_001      OSB\n",
              "90360      134182  1606862666388       2425.0  ...   os_021     osb_001      OSB\n",
              "90371      134193  1606862666681       3539.0  ...   os_021     osb_001      OSB\n",
              "90372      134194  1606862667270       3055.0  ...   os_021     osb_001      OSB\n",
              "90373      134195  1606862666905       3433.0  ...   os_021     osb_001      OSB\n",
              "90423      134245  1606862700025       2404.0  ...   os_021     osb_001      OSB\n",
              "90424      134246  1606862700025       2406.0  ...   os_021     osb_001      OSB\n",
              "90425      134247  1606862700026       2408.0  ...   os_021     osb_001      OSB\n",
              "90563      134385  1606862707327       2809.0  ...   os_022     osb_001      OSB\n",
              "90699      134521  1606862716630       2645.0  ...   os_021     osb_001      OSB\n",
              "90700      134522  1606862716772       2602.0  ...   os_021     osb_001      OSB\n",
              "90701      134523  1606862716768       2720.0  ...   os_021     osb_001      OSB\n",
              "90703      134525  1606862717100       2477.0  ...   os_021     osb_001      OSB\n",
              "91214      135036  1606862778550       2525.0  ...   os_021     osb_001      OSB\n",
              "91227      135049  1606862779444       2528.0  ...   os_021     osb_001      OSB\n",
              "91228      135050  1606862779708       2461.0  ...   os_021     osb_001      OSB\n",
              "91229      135051  1606862779880       2593.0  ...   os_021     osb_001      OSB\n",
              "91290      135112  1606862784751       2555.0  ...   os_021     osb_001      OSB\n",
              "91297      135119  1606862784806       3021.0  ...   os_021     osb_001      OSB\n",
              "91302      135124  1606862784736       3581.0  ...   os_021     osb_001      OSB\n",
              "91304      135126  1606862784959       3549.0  ...   os_021     osb_001      OSB\n",
              "91306      135128  1606862784702       4013.0  ...   os_021     osb_001      OSB\n",
              "91309      135131  1606862785935       2980.0  ...   os_021     osb_001      OSB\n",
              "91314      135136  1606862786819       2687.0  ...   os_021     osb_001      OSB\n",
              "\n",
              "[50 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 36
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "bfime3BWOEwx",
        "outputId": "545d933c-f90b-4450-96f6-27b831ad15d8"
      },
      "source": [
        "small_trace['elapsedTime'].describe()"
      ],
      "execution_count": 39,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "count    2419.000000\n",
              "mean      604.335676\n",
              "std       595.355222\n",
              "min        69.000000\n",
              "25%       206.000000\n",
              "50%       349.000000\n",
              "75%       760.000000\n",
              "max      4013.000000\n",
              "Name: elapsedTime, dtype: float64"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 39
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "FeSPP5KRQoua"
      },
      "source": [
        "import pickle\r\n",
        "with open('clustering_model.pickle', 'wb') as f:\r\n",
        "  pickle.dump(brc,f)\r\n"
      ],
      "execution_count": 42,
      "outputs": []
    }
  ]
}